package edu.sugar.mapper;

import edu.sugar.bean.KW;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TrafficMapper {
    @Select(" select  keyword,  sum(keyword_count) score from dws_traffic_source_keyword_page_view_window" +
            " where toYYYYMMDD(stt) = #{date}  group by keyword")
    public List<KW> kw(int date);
}
